Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Compound Expressions

A compound expression specifies a combination of other expressions.

compound_expression::=

Description of the illustration compound_expression.gif

You can use any built-in function as an expression ("Function Expressions"). However, in a compound expression, some combinations of functions are inappropriate and are rejected. For example, the `LENGTH` function is inappropriate within an aggregate function.

The `PRIOR` operator is used in `CONNECT` `BY` clauses of hierarchical queries.

See Also: "Operator Precedence" and "Hierarchical Queries"

Some valid compound expressions are:

    ('CLARK' || 'SMITH')
    LENGTH('MOOSE') * 57
    SQRT(144) + 72
    my_fun(TO_CHAR(sysdate,'DD-MMM-YY'))